UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BtzSnGkJ0IYGygPlhFV9utJLZVO1MYsiNE9i2Nq8vI0='
WHERE
key_id = '33163a9068cccc3463841ce63bb9ef0d92cbd7dd9b327a5844f4b6819f31a510'
AND (
token = 'BtzSnGkJ0IYGygPlhFV9utJLZVO1MYsiNE9i2Nq8vI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)