UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vC69kPUTaewD/WbVeXPG3whdn1DcOl88GvfCIE6hbLM='
WHERE
key_id = '7b9b78f616db381f6c45c42f9854aa44d0b3607497619634d65968eee5bd471e'
AND (
token = 'vC69kPUTaewD/WbVeXPG3whdn1DcOl88GvfCIE6hbLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)