UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vrzjcxJIo25CusvQL9+E0YYrrh6kCaRREVn4a5yXrw='
WHERE
key_id = 'c749faa0ebfbca15fbcfa8de8b209180d059872c963c458fffaf6e016d1e7421'
AND (
token = '6vrzjcxJIo25CusvQL9+E0YYrrh6kCaRREVn4a5yXrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)