UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xXRGwSqaEZNOYpgS+lg9IKieCjjTLrwlCBkA8y1LKvQ='
WHERE
key_id = 'd304b8afb92220218c81a2e81f31d37f6788a2d76bbb887a8cd46e8affa6b90f'
AND (
token = 'xXRGwSqaEZNOYpgS+lg9IKieCjjTLrwlCBkA8y1LKvQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)