UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sm0w9caEumDFb5lH6xL3x+HqENiOhM5lK24XDHi8+FE='
WHERE
key_id = 'feef7e382ba8af91b61d489a729bc21af5543a2296741b2ca2c963621949a893'
AND (
token = 'Sm0w9caEumDFb5lH6xL3x+HqENiOhM5lK24XDHi8+FE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)