UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ct7XDuidlMLMOfr8ikTfmy5pYSp0rYd72n6tuwvCXR0='
WHERE
key_id = 'a2a0d0d12e22fae066fb30d677ecc4f2416efcbd09b91c346343eaa2f1a2bd8d'
AND (
token = 'Ct7XDuidlMLMOfr8ikTfmy5pYSp0rYd72n6tuwvCXR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)