UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DT/wKjXY9+NkzGwpAER9RDRWr/epImVq6MSn1wcfTP8='
WHERE
key_id = '46112ea22e1ac7855acf4ab12e3ae5b0e0a5a0c60c319609b63e8f65500ff645'
AND (
token = 'DT/wKjXY9+NkzGwpAER9RDRWr/epImVq6MSn1wcfTP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)