UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WnbyZm+y89jtxRUu2dTuxEE4d1/xuDmnKEMMe5To+9s='
WHERE
key_id = 'f968b5c7941d7965fc85f7453da0cbe78b2c83b0877ffeb20654553404c6cb9a'
AND (
token = 'WnbyZm+y89jtxRUu2dTuxEE4d1/xuDmnKEMMe5To+9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)