UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tdvt0mqPUO9qy/HIW+aNeh8Q/wh7bD2aA4ZM+qCNe7Q='
WHERE
key_id = 'bc1f5d5711217c7d58b54b4297666fae5fb592a5a11ac7e1ae4126884317b5fc'
AND (
token = 'Tdvt0mqPUO9qy/HIW+aNeh8Q/wh7bD2aA4ZM+qCNe7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)