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