UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vwmsVOhd4XnTonPi+GaiRQ3q06v1mpnimQJHV1V4Crg=' 
WHERE 
  key_id = '7efd84f884d518ad6514478b2005ad86c2b761e157dc66dd97332385ff7f4acf' 
  AND (
    token = 'vwmsVOhd4XnTonPi+GaiRQ3q06v1mpnimQJHV1V4Crg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032