UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5c9i0d9+R7RzXAqWIF0gWy2yF1s/j2Ui4G+MojYsaGY=' 
WHERE 
  key_id = 'd655890ca508ef1c54250ef30dc2b634dd2423b955a2c9e7242d72efaef07426' 
  AND (
    token = '5c9i0d9+R7RzXAqWIF0gWy2yF1s/j2Ui4G+MojYsaGY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027