UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jhCIcxRXum1IS0KzV6c4ik3Rjd5zCfkzrAqrooPpm5I='
WHERE
key_id = '7875beda6849b7e7e66ad4ff5412ebbbfcd8cfe889e039fcaab55597d3717b5c'
AND (
token = 'jhCIcxRXum1IS0KzV6c4ik3Rjd5zCfkzrAqrooPpm5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)