UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sqCfgcLSgx3S27aamHIW+7nGF5xCHDeasiiA5P425Dk='
WHERE
key_id = 'ed5dacd31327fd09ba5f2f1cee82e8b98baae7ae76a97d56472cc329040c4ed8'
AND (
token = 'sqCfgcLSgx3S27aamHIW+7nGF5xCHDeasiiA5P425Dk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)