UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNVkfWPTUkdfwZf9MgGF0JgmW6/BHq4LcMvovSo59GA='
WHERE
key_id = '7a9417ff1057e466c40f9a1c827bea75190a08ac10af70995eb63dbb1bc9efbc'
AND (
token = 'KNVkfWPTUkdfwZf9MgGF0JgmW6/BHq4LcMvovSo59GA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)