UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zIzuphRAr88VS1cVs1bV1J9Kb7M/J7ufBy5VFrIi4yY=' 
WHERE 
  key_id = '0f5efc1f3964c30ba7435e71cd1048c8826b2d7f2c79ef0cd59a23d50b51faa6' 
  AND (
    token = 'zIzuphRAr88VS1cVs1bV1J9Kb7M/J7ufBy5VFrIi4yY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036