UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CNQ9dqhIOFRvewxPJk0EoabIX1DJvZAwaR0RqW88VHo='
WHERE
key_id = '63e9a43e7a979a0feaa9c35ebba0c144d5c336d64fcaa4890a3add62217b082a'
AND (
token = 'CNQ9dqhIOFRvewxPJk0EoabIX1DJvZAwaR0RqW88VHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)