UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBFFiOcBcM3JdB4DyVcDLiTwzUWdWME17GorzTt/9DY='
WHERE
key_id = '9ba60c15957c71912071b2349250f61a3a1bb23cba24ea86acf136bc65ea2feb'
AND (
token = 'zBFFiOcBcM3JdB4DyVcDLiTwzUWdWME17GorzTt/9DY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)