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