UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j2XcWqAlgLAHtL0wp0rNUvxAD1EqiJJf3z0WiSYb4pI='
WHERE
key_id = '9c519b6be84cc6f4fc4dbc5085ea28c4c00abd3e48d89899dd5c51011750ee15'
AND (
token = 'j2XcWqAlgLAHtL0wp0rNUvxAD1EqiJJf3z0WiSYb4pI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)