UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YXKKRMBZGPr4CbNEkxNmDqb+ZeJsucV0SiwbpMqcNw='
WHERE
key_id = 'e78a2f25fbb2122f67ca46bab3c17bd428e8f39669a5cfb2d56bc129dca42ce2'
AND (
token = '1YXKKRMBZGPr4CbNEkxNmDqb+ZeJsucV0SiwbpMqcNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)