UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'myB9YUHeKiv9OU2y9PWyg0v1y8usYsTVv3zt99kp7LU='
WHERE
key_id = '0d2316487aee77a06f3e7177220b73cf94f194f311005252308308ce36a5c16d'
AND (
token = 'myB9YUHeKiv9OU2y9PWyg0v1y8usYsTVv3zt99kp7LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)