UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kZN9IesdM+knYuaFjPrxt6MtmHDP2Ih5662SeHOOmew='
WHERE
key_id = '97e37612496b6a5cff4ec79f97adfa1881d7d9484eece4bcecb626ad63a55065'
AND (
token = 'kZN9IesdM+knYuaFjPrxt6MtmHDP2Ih5662SeHOOmew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)