UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N61mkZFoK3VgO6Tb3QkznoZ47CxBbOIX/R+AV1kzpHY='
WHERE
key_id = '8cbdfc49e385b45338b512907a9e35fbef9a5f601f81912c0e8a2f27de728946'
AND (
token = 'N61mkZFoK3VgO6Tb3QkznoZ47CxBbOIX/R+AV1kzpHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)