UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sz29YcjxnxEolHd9iYdOWm59bhG1zLVmUcdHT3tzpXM='
WHERE
key_id = 'cea5c9bf5da10f1397c40f012e2c1b58be65e520074c2272e4fad8f4f5a0179f'
AND (
token = 'Sz29YcjxnxEolHd9iYdOWm59bhG1zLVmUcdHT3tzpXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)