UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ixhFcM26odCRmHZWsUefWRQeRD8c0N12An0/3X5M+N8='
WHERE
key_id = 'cf8140afabbe8868e89d1bc9e9e208a7e22f4ccab89b77efa56e1fe5eb8f9676'
AND (
token = 'ixhFcM26odCRmHZWsUefWRQeRD8c0N12An0/3X5M+N8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)