UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWcSjpwki4NqF4J3d4SF7RHpGp2aYh0Fqgf7OE7tyhs='
WHERE
key_id = '7f5b5ed971bf1cb57cc8fc6bee419f63dcb6217418d4a68b17403cc655be2925'
AND (
token = 'ZWcSjpwki4NqF4J3d4SF7RHpGp2aYh0Fqgf7OE7tyhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)