UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8f6ijGHWi4vJ+4MIHnIkr3f2VKO+W4RQdXlkQvuCHOQ=' 
WHERE 
  key_id = '8460ec3b8319d1b5e63dfd6183d697d590d9157fe32fb4f2297ee7f7b5b9fab9' 
  AND (
    token = '8f6ijGHWi4vJ+4MIHnIkr3f2VKO+W4RQdXlkQvuCHOQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047