UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8BGR9noGkDRC3P+3zAUlGRnJFTMFu59wEy33G7xYGY='
WHERE
key_id = 'a69c1990a38b5b41c869320a1ed6a246a016d40d2c433c5174151299aff6ce49'
AND (
token = 'q8BGR9noGkDRC3P+3zAUlGRnJFTMFu59wEy33G7xYGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)