UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MouuqAIEJ6ecqMFet6XD6L0tyhnVUVmMx3VSD8fSd+A='
WHERE
key_id = 'bcc1f744ba003fce3a2f5e47d20011aaa0f9a3d718dc4d6aae854e8120e9b9a6'
AND (
token = 'MouuqAIEJ6ecqMFet6XD6L0tyhnVUVmMx3VSD8fSd+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)