UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oO1gybfh/Ttjc8fSrPB0UUCR9Qd1+o8Ni5sH8O2lCY8=' 
WHERE 
  key_id = 'cd21c7651bfae8a4b2a1e3ab19319ffe40bf1510565b90c56b3364f7d84eb603' 
  AND (
    token = 'oO1gybfh/Ttjc8fSrPB0UUCR9Qd1+o8Ni5sH8O2lCY8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028