UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ibXUa3mHBcD6nxtLk223VLtcqZJ5Qivdscti7O6b5dc='
WHERE
key_id = 'ffd4e1e7f63714b9a0be6cf6f7518544ba88056a2dac3d213def90c3583e4b7a'
AND (
token = 'ibXUa3mHBcD6nxtLk223VLtcqZJ5Qivdscti7O6b5dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)